Dataset statistics
| Number of variables | 30 |
|---|---|
| Number of observations | 897406 |
| Missing cells | 10106416 |
| Missing cells (%) | 37.5% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 205.4 MiB |
| Average record size in memory | 240.0 B |
Variable types
| CAT | 25 |
|---|---|
| NUM | 4 |
| BOOL | 1 |
Reproduction
| Analysis started | 2020-07-05 20:57:27.256867 |
|---|---|
| Analysis finished | 2020-07-05 20:58:57.947360 |
| Duration | 1 minute and 30.69 seconds |
| Version | pandas-profiling v2.8.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download configuration | config.yaml |
CRASH_RECORD_ID has a high cardinality: 410559 distinct values | High cardinality |
RD_NO has a high cardinality: 407135 distinct values | High cardinality |
CRASH_DATE has a high cardinality: 265855 distinct values | High cardinality |
CITY has a high cardinality: 9084 distinct values | High cardinality |
STATE has a high cardinality: 52 distinct values | High cardinality |
ZIPCODE has a high cardinality: 10074 distinct values | High cardinality |
DRIVERS_LICENSE_STATE has a high cardinality: 177 distinct values | High cardinality |
DRIVERS_LICENSE_CLASS has a high cardinality: 222 distinct values | High cardinality |
HOSPITAL has a high cardinality: 4356 distinct values | High cardinality |
EMS_AGENCY has a high cardinality: 5461 distinct values | High cardinality |
EMS_RUN_NO has a high cardinality: 846 distinct values | High cardinality |
VEHICLE_ID has 17276 (1.9%) missing values | Missing |
SEAT_NO has 721616 (80.4%) missing values | Missing |
CITY has 228441 (25.5%) missing values | Missing |
STATE has 222539 (24.8%) missing values | Missing |
ZIPCODE has 284715 (31.7%) missing values | Missing |
SEX has 12438 (1.4%) missing values | Missing |
AGE has 251813 (28.1%) missing values | Missing |
DRIVERS_LICENSE_STATE has 355637 (39.6%) missing values | Missing |
DRIVERS_LICENSE_CLASS has 422545 (47.1%) missing values | Missing |
AIRBAG_DEPLOYED has 16885 (1.9%) missing values | Missing |
EJECTION has 11022 (1.2%) missing values | Missing |
HOSPITAL has 733805 (81.8%) missing values | Missing |
EMS_AGENCY has 792989 (88.4%) missing values | Missing |
EMS_RUN_NO has 881237 (98.2%) missing values | Missing |
DRIVER_ACTION has 177503 (19.8%) missing values | Missing |
DRIVER_VISION has 177721 (19.8%) missing values | Missing |
PHYSICAL_CONDITION has 176972 (19.7%) missing values | Missing |
PEDPEDAL_ACTION has 880703 (98.1%) missing values | Missing |
PEDPEDAL_VISIBILITY has 880744 (98.1%) missing values | Missing |
PEDPEDAL_LOCATION has 880701 (98.1%) missing values | Missing |
BAC_RESULT has 176397 (19.7%) missing values | Missing |
BAC_RESULT VALUE has 896257 (99.9%) missing values | Missing |
CELL_PHONE_USE has 896261 (99.9%) missing values | Missing |
CRASH_RECORD_ID is uniformly distributed | Uniform |
RD_NO is uniformly distributed | Uniform |
PERSON_ID has unique values | Unique |
| Distinct count | 897406 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.8 MiB |
| O422964 | 1 |
|---|---|
| O461101 | 1 |
| P153650 | 1 |
| O871108 | 1 |
| O504571 | 1 |
| Other values (897401) |
| Value | Count | Frequency (%) | |
| O422964 | 1 | < 0.1% | |
| O461101 | 1 | < 0.1% | |
| P153650 | 1 | < 0.1% | |
| O871108 | 1 | < 0.1% | |
| O504571 | 1 | < 0.1% | |
| O129734 | 1 | < 0.1% | |
| O139189 | 1 | < 0.1% | |
| O281051 | 1 | < 0.1% | |
| O38512 | 1 | < 0.1% | |
| O721848 | 1 | < 0.1% | |
| Other values (897396) | 897396 | > 99.9% |
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 6.788244117 |
| Min length | 2 |
PERSON_TYPE
Categorical
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.8 MiB |
| DRIVER | |
|---|---|
| PASSENGER | |
| PEDESTRIAN | 10482 |
| BICYCLE | 5974 |
| NON-MOTOR VEHICLE | 750 |
| Value | Count | Frequency (%) | |
| DRIVER | 704250 | 78.5% | |
| PASSENGER | 175790 | 19.6% | |
| PEDESTRIAN | 10482 | 1.2% | |
| BICYCLE | 5974 | 0.7% | |
| NON-MOTOR VEHICLE | 750 | 0.1% | |
| NON-CONTACT VEHICLE | 160 | < 0.1% |
Length
| Max length | 19 |
|---|---|
| Median length | 6 |
| Mean length | 6.652549682 |
| Min length | 6 |
| Distinct count | 410559 |
|---|---|
| Unique (%) | 45.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.8 MiB |
| 31ecf6862c691ff12d3856213b902c146b07337b42a5692e3a176a66d684d221028bb5118ef6d67a313bcaed9e97bee1855cb1f5e8650f49e8dc17663475a1ee | 61 |
|---|---|
| 13026c7fb51566d9ca487a093e38c6f5621c2ec25be48c306b6574983b61daeee589524b96bb2bfe66ddd0f695c8d2bf3ab0297558528e9c7a70363c763d6bd1 | 50 |
| c727dc759107cf17b2e8141149347128bb4bc26b026c7805562206c7c5761c543dd7cc0e47fc11379455a2ecbb2847c3d1744d6feb78f276d9a457e9beeb6121 | 45 |
| 1829f52c1281a0396ef94692331b3dc530bc4be5a54cd55e94c24a5e5e49b800fbcf9f24dabe4c8277c8964ad05aadc89e90fd94021959d6dff5fad55480d595 | 45 |
| 60fbcef1942e23e9d93ba3fd5dd7f1da2c5b1e4bcc30731363a0f9ed822b5971a38d109cace85875dc2a7321d8a28ba40f24548d9ddd728f600af3b08c036a70 | 44 |
| Other values (410554) |
| Value | Count | Frequency (%) | |
| 31ecf6862c691ff12d3856213b902c146b07337b42a5692e3a176a66d684d221028bb5118ef6d67a313bcaed9e97bee1855cb1f5e8650f49e8dc17663475a1ee | 61 | < 0.1% | |
| 13026c7fb51566d9ca487a093e38c6f5621c2ec25be48c306b6574983b61daeee589524b96bb2bfe66ddd0f695c8d2bf3ab0297558528e9c7a70363c763d6bd1 | 50 | < 0.1% | |
| c727dc759107cf17b2e8141149347128bb4bc26b026c7805562206c7c5761c543dd7cc0e47fc11379455a2ecbb2847c3d1744d6feb78f276d9a457e9beeb6121 | 45 | < 0.1% | |
| 1829f52c1281a0396ef94692331b3dc530bc4be5a54cd55e94c24a5e5e49b800fbcf9f24dabe4c8277c8964ad05aadc89e90fd94021959d6dff5fad55480d595 | 45 | < 0.1% | |
| 60fbcef1942e23e9d93ba3fd5dd7f1da2c5b1e4bcc30731363a0f9ed822b5971a38d109cace85875dc2a7321d8a28ba40f24548d9ddd728f600af3b08c036a70 | 44 | < 0.1% | |
| 17afe1e4e4367dc3dcfca167fd32d6cab39e6a517863885610d5af743895769a916d20ac3094919b287724806ee9ccfba594abf57e9223a187eab3acd55b90be | 42 | < 0.1% | |
| 95741c5fca615c892ab34d22a08da8da4a04594d1b2b989ab96e7e43a59ce144152bd50793d5ca75a8590f6f30f5409c577a43b38ec9c8126bee83ff3c4367bf | 42 | < 0.1% | |
| 6b96de25ec212e980c0ab42fd01771d64737ccd9c3bed72fd26357d35f8ac00d8e3e1dfaed4c91f3159d8ed15ba4267946720443d9fb34a55b1839c5a4ae3281 | 40 | < 0.1% | |
| 61bee823dd33ba8c08b79c23806840fe0ca32f48aedc443c05b258b7d294bbef029e904d9b4b2a8eb10878d04fd6e488c018065a593216d26022c590ec70d642 | 40 | < 0.1% | |
| b8c1315393f8d3155c03fe6967516695ca7be422ca3fa936f3301f634f8775ae8025ef081804eaf0621bba6e00df09850edd742d5a82a0072937ef3a6cbae848 | 39 | < 0.1% | |
| Other values (410549) | 896958 | > 99.9% |
Length
| Max length | 128 |
|---|---|
| Median length | 128 |
| Mean length | 128 |
| Min length | 128 |
| Distinct count | 407135 |
|---|---|
| Unique (%) | 45.7% |
| Missing | 7331 |
| Missing (%) | 0.8% |
| Memory size | 6.8 MiB |
| JB187770 | 61 |
|---|---|
| JC317468 | 50 |
| JA283201 | 45 |
| JB253311 | 45 |
| HZ139917 | 44 |
| Other values (407130) |
| Value | Count | Frequency (%) | |
| JB187770 | 61 | < 0.1% | |
| JC317468 | 50 | < 0.1% | |
| JA283201 | 45 | < 0.1% | |
| JB253311 | 45 | < 0.1% | |
| HZ139917 | 44 | < 0.1% | |
| JC525033 | 42 | < 0.1% | |
| JB343346 | 42 | < 0.1% | |
| JB274889 | 40 | < 0.1% | |
| JB451258 | 40 | < 0.1% | |
| JB257740 | 39 | < 0.1% | |
| Other values (407125) | 889627 | 99.1% | |
| (Missing) | 7331 | 0.8% |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 7.959154496 |
| Min length | 3 |
| Distinct count | 712476 |
|---|---|
| Unique (%) | 81.0% |
| Missing | 17276 |
| Missing (%) | 1.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 426379.0620896913 |
|---|---|
| Minimum | 2.0 |
| Maximum | 856686.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 6.8 MiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 42048.45 |
| Q1 | 213929.25 |
| median | 425045.5 |
| Q3 | 639390 |
| 95-th percentile | 811141.55 |
| Maximum | 856686 |
| Range | 856684 |
| Interquartile range (IQR) | 425460.75 |
Descriptive statistics
| Standard deviation | 246268.9907 |
|---|---|
| Coefficient of variation (CV) | 0.5775822796 |
| Kurtosis | -1.192782366 |
| Mean | 426379.0621 |
| Median Absolute Deviation (MAD) | 212832 |
| Skewness | 0.005795908982 |
| Sum | 3.752690039e+11 |
| Variance | 6.064841576e+10 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 332155 | 60 | < 0.1% | |
| 643997 | 47 | < 0.1% | |
| 162199 | 44 | < 0.1% | |
| 366311 | 44 | < 0.1% | |
| 25920 | 43 | < 0.1% | |
| 412312 | 41 | < 0.1% | |
| 750399 | 41 | < 0.1% | |
| 464998 | 39 | < 0.1% | |
| 377323 | 39 | < 0.1% | |
| 662902 | 38 | < 0.1% | |
| Other values (712466) | 879694 | 98.0% | |
| (Missing) | 17276 | 1.9% |
| Value | Count | Frequency (%) | |
| 2 | 1 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 4 | 1 | < 0.1% | |
| 6 | 1 | < 0.1% | |
| 7 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 856686 | 1 | < 0.1% | |
| 856680 | 1 | < 0.1% | |
| 856678 | 1 | < 0.1% | |
| 856674 | 1 | < 0.1% | |
| 856670 | 1 | < 0.1% |
| Distinct count | 265855 |
|---|---|
| Unique (%) | 29.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.8 MiB |
| 11/10/2017 10:30:00 AM | 64 |
|---|---|
| 03/16/2018 10:17:00 AM | 61 |
| 06/22/2019 06:15:00 PM | 55 |
| 09/26/2018 07:30:00 AM | 48 |
| 05/07/2018 09:35:00 AM | 47 |
| Other values (265850) |
| Value | Count | Frequency (%) | |
| 11/10/2017 10:30:00 AM | 64 | < 0.1% | |
| 03/16/2018 10:17:00 AM | 61 | < 0.1% | |
| 06/22/2019 06:15:00 PM | 55 | < 0.1% | |
| 09/26/2018 07:30:00 AM | 48 | < 0.1% | |
| 05/07/2018 09:35:00 AM | 47 | < 0.1% | |
| 07/10/2018 09:10:00 AM | 45 | < 0.1% | |
| 05/28/2017 11:37:00 PM | 45 | < 0.1% | |
| 02/04/2016 09:30:00 AM | 44 | < 0.1% | |
| 11/10/2017 10:00:00 AM | 43 | < 0.1% | |
| 11/26/2019 10:50:00 AM | 42 | < 0.1% | |
| Other values (265845) | 896912 | 99.9% |
Length
| Max length | 22 |
|---|---|
| Median length | 22 |
| Mean length | 22 |
| Min length | 22 |
| Distinct count | 11 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 721616 |
| Missing (%) | 80.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.202582626998122 |
|---|---|
| Minimum | 1.0 |
| Maximum | 12.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 6.8 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 3 |
| median | 3 |
| Q3 | 6 |
| 95-th percentile | 10 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 2.181656361 |
|---|---|
| Coefficient of variation (CV) | 0.5191227764 |
| Kurtosis | 3.408036626 |
| Mean | 4.202582627 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.718990198 |
| Sum | 738772 |
| Variance | 4.759624479 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 3 | 83082 | 9.3% | |
| 6 | 31265 | 3.5% | |
| 4 | 24570 | 2.7% | |
| 5 | 8627 | 1.0% | |
| 1 | 7294 | 0.8% | |
| 2 | 6604 | 0.7% | |
| 7 | 4449 | 0.5% | |
| 12 | 4430 | 0.5% | |
| 10 | 3798 | 0.4% | |
| 11 | 1456 | 0.2% | |
| (Missing) | 721616 | 80.4% |
| Value | Count | Frequency (%) | |
| 1 | 7294 | 0.8% | |
| 2 | 6604 | 0.7% | |
| 3 | 83082 | 9.3% | |
| 4 | 24570 | 2.7% | |
| 5 | 8627 | 1.0% |
| Value | Count | Frequency (%) | |
| 12 | 4430 | 0.5% | |
| 11 | 1456 | 0.2% | |
| 10 | 3798 | 0.4% | |
| 8 | 215 | < 0.1% | |
| 7 | 4449 | 0.5% |
| Distinct count | 9084 |
|---|---|
| Unique (%) | 1.4% |
| Missing | 228441 |
| Missing (%) | 25.5% |
| Memory size | 6.8 MiB |
| CHICAGO | |
|---|---|
| CICERO | 6551 |
| SKOKIE | 4685 |
| EVANSTON | 3945 |
| BERWYN | 3840 |
| Other values (9079) |
| Value | Count | Frequency (%) | |
| CHICAGO | 470508 | 52.4% | |
| CICERO | 6551 | 0.7% | |
| SKOKIE | 4685 | 0.5% | |
| EVANSTON | 3945 | 0.4% | |
| BERWYN | 3840 | 0.4% | |
| UNKNOWN | 3458 | 0.4% | |
| OAK LAWN | 3253 | 0.4% | |
| CALUMET CITY | 3253 | 0.4% | |
| OAK PARK | 2852 | 0.3% | |
| DES PLAINES | 2578 | 0.3% | |
| Other values (9074) | 164042 | 18.3% | |
| (Missing) | 228441 | 25.5% |
Length
| Max length | 48 |
|---|---|
| Median length | 7 |
| Mean length | 6.424887955 |
| Min length | 1 |
| Distinct count | 52 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 222539 |
| Missing (%) | 24.8% |
| Memory size | 6.8 MiB |
| IL | |
|---|---|
| IN | 10094 |
| XX | 4410 |
| WI | 3102 |
| MI | 2545 |
| Other values (47) | 15753 |
| Value | Count | Frequency (%) | |
| IL | 638963 | 71.2% | |
| IN | 10094 | 1.1% | |
| XX | 4410 | 0.5% | |
| WI | 3102 | 0.3% | |
| MI | 2545 | 0.3% | |
| FL | 1627 | 0.2% | |
| TX | 1275 | 0.1% | |
| OH | 1237 | 0.1% | |
| CA | 1228 | 0.1% | |
| IA | 934 | 0.1% | |
| Other values (42) | 9452 | 1.1% | |
| (Missing) | 222539 | 24.8% |
Length
| Max length | 3 |
|---|---|
| Median length | 2 |
| Mean length | 2.24798029 |
| Min length | 2 |
| Distinct count | 10074 |
|---|---|
| Unique (%) | 1.6% |
| Missing | 284715 |
| Missing (%) | 31.7% |
| Memory size | 6.8 MiB |
| 60629 | 21968 |
|---|---|
| 60639 | 18302 |
| 60620 | 16323 |
| 60617 | 15730 |
| 60619 | 15148 |
| Other values (10069) |
| Value | Count | Frequency (%) | |
| 60629 | 21968 | 2.4% | |
| 60639 | 18302 | 2.0% | |
| 60620 | 16323 | 1.8% | |
| 60617 | 15730 | 1.8% | |
| 60619 | 15148 | 1.7% | |
| 60623 | 14727 | 1.6% | |
| 60632 | 14618 | 1.6% | |
| 60651 | 14298 | 1.6% | |
| 60628 | 13883 | 1.5% | |
| 60641 | 12555 | 1.4% | |
| Other values (10064) | 455139 | 50.7% | |
| (Missing) | 284715 | 31.7% |
Length
| Max length | 10 |
|---|---|
| Median length | 5 |
| Mean length | 4.368441932 |
| Min length | 1 |
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 12438 |
| Missing (%) | 1.4% |
| Memory size | 6.8 MiB |
| M | |
|---|---|
| F | |
| X | 65818 |
| U | 7296 |
| Value | Count | Frequency (%) | |
| M | 470501 | 52.4% | |
| F | 341353 | 38.0% | |
| X | 65818 | 7.3% | |
| U | 7296 | 0.8% | |
| (Missing) | 12438 | 1.4% |
Length
| Max length | 3 |
|---|---|
| Median length | 1 |
| Mean length | 1.027719895 |
| Min length | 1 |
| Distinct count | 112 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 251813 |
| Missing (%) | 28.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 38.07236757523703 |
|---|---|
| Minimum | -49.0 |
| Maximum | 110.0 |
| Zeros | 7974 |
| Zeros (%) | 0.9% |
| Memory size | 6.8 MiB |
Quantile statistics
| Minimum | -49 |
|---|---|
| 5-th percentile | 13 |
| Q1 | 26 |
| median | 36 |
| Q3 | 50 |
| 95-th percentile | 68 |
| Maximum | 110 |
| Range | 159 |
| Interquartile range (IQR) | 24 |
Descriptive statistics
| Standard deviation | 17.08623032 |
|---|---|
| Coefficient of variation (CV) | 0.4487829733 |
| Kurtosis | -0.2444726847 |
| Mean | 38.07236758 |
| Median Absolute Deviation (MAD) | 12 |
| Skewness | 0.299186618 |
| Sum | 24579254 |
| Variance | 291.9392666 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 25 | 18382 | 2.0% | |
| 27 | 18319 | 2.0% | |
| 26 | 18274 | 2.0% | |
| 24 | 17879 | 2.0% | |
| 28 | 17786 | 2.0% | |
| 29 | 17177 | 1.9% | |
| 23 | 16604 | 1.9% | |
| 30 | 16018 | 1.8% | |
| 31 | 15464 | 1.7% | |
| 22 | 15174 | 1.7% | |
| Other values (102) | 474516 | 52.9% | |
| (Missing) | 251813 | 28.1% |
| Value | Count | Frequency (%) | |
| -49 | 1 | < 0.1% | |
| -1 | 1 | < 0.1% | |
| 0 | 7974 | 0.9% | |
| 1 | 2068 | 0.2% | |
| 2 | 1949 | 0.2% |
| Value | Count | Frequency (%) | |
| 110 | 3 | < 0.1% | |
| 109 | 6 | < 0.1% | |
| 108 | 3 | < 0.1% | |
| 107 | 4 | < 0.1% | |
| 106 | 1 | < 0.1% |
| Distinct count | 177 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 355637 |
| Missing (%) | 39.6% |
| Memory size | 6.8 MiB |
| IL | |
|---|---|
| XX | 10791 |
| IN | 8816 |
| WI | 2900 |
| MI | 2415 |
| Other values (172) | 17679 |
| Value | Count | Frequency (%) | |
| IL | 499168 | 55.6% | |
| XX | 10791 | 1.2% | |
| IN | 8816 | 1.0% | |
| WI | 2900 | 0.3% | |
| MI | 2415 | 0.3% | |
| FL | 1865 | 0.2% | |
| CA | 1380 | 0.2% | |
| TX | 1355 | 0.2% | |
| OH | 1172 | 0.1% | |
| IA | 888 | 0.1% | |
| Other values (167) | 11019 | 1.2% | |
| (Missing) | 355637 | 39.6% |
Length
| Max length | 3 |
|---|---|
| Median length | 2 |
| Mean length | 2.396294431 |
| Min length | 2 |
| Distinct count | 222 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 422545 |
| Missing (%) | 47.1% |
| Memory size | 6.8 MiB |
| D | |
|---|---|
| A | 15854 |
| C | 12980 |
| B | 12723 |
| DM | 8025 |
| Other values (217) | 11687 |
| Value | Count | Frequency (%) | |
| D | 413592 | 46.1% | |
| A | 15854 | 1.8% | |
| C | 12980 | 1.4% | |
| B | 12723 | 1.4% | |
| DM | 8025 | 0.9% | |
| AM | 1901 | 0.2% | |
| CD | 1505 | 0.2% | |
| BM | 1136 | 0.1% | |
| E | 951 | 0.1% | |
| O | 794 | 0.1% | |
| Other values (212) | 5400 | 0.6% | |
| (Missing) | 422545 | 47.1% |
Length
| Max length | 3 |
|---|---|
| Median length | 1 |
| Mean length | 1.959476536 |
| Min length | 1 |
SAFETY_EQUIPMENT
Categorical
| Distinct count | 19 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 2520 |
| Missing (%) | 0.3% |
| Memory size | 6.8 MiB |
| SAFETY BELT USED | |
|---|---|
| USAGE UNKNOWN | |
| NONE PRESENT | 27775 |
| CHILD RESTRAINT USED | 7360 |
| SAFETY BELT NOT USED | 5407 |
| Other values (14) | 8412 |
| Value | Count | Frequency (%) | |
| SAFETY BELT USED | 461481 | 51.4% | |
| USAGE UNKNOWN | 384451 | 42.8% | |
| NONE PRESENT | 27775 | 3.1% | |
| CHILD RESTRAINT USED | 7360 | 0.8% | |
| SAFETY BELT NOT USED | 5407 | 0.6% | |
| HELMET NOT USED | 2685 | 0.3% | |
| HELMET USED | 1332 | 0.1% | |
| CHILD RESTRAINT - FORWARD FACING | 1146 | 0.1% | |
| BICYCLE HELMET (PEDACYCLIST INVOLVED ONLY) | 818 | 0.1% | |
| CHILD RESTRAINT - REAR FACING | 584 | 0.1% | |
| Other values (9) | 1847 | 0.2% | |
| (Missing) | 2520 | 0.3% |
Length
| Max length | 42 |
|---|---|
| Median length | 16 |
| Mean length | 14.672359 |
| Min length | 3 |
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 16885 |
| Missing (%) | 1.9% |
| Memory size | 6.8 MiB |
| DID NOT DEPLOY | |
|---|---|
| DEPLOYMENT UNKNOWN | |
| NOT APPLICABLE | |
| DEPLOYED, FRONT | 24591 |
| DEPLOYED, COMBINATION | 14138 |
| Other values (2) | 6730 |
| Value | Count | Frequency (%) | |
| DID NOT DEPLOY | 554673 | 61.8% | |
| DEPLOYMENT UNKNOWN | 168052 | 18.7% | |
| NOT APPLICABLE | 112337 | 12.5% | |
| DEPLOYED, FRONT | 24591 | 2.7% | |
| DEPLOYED, COMBINATION | 14138 | 1.6% | |
| DEPLOYED, SIDE | 6397 | 0.7% | |
| DEPLOYED OTHER (KNEE, AIR, BELT, ETC.) | 333 | < 0.1% | |
| (Missing) | 16885 | 1.9% |
Length
| Max length | 38 |
|---|---|
| Median length | 14 |
| Mean length | 14.68867603 |
| Min length | 3 |
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 11022 |
| Missing (%) | 1.2% |
| Memory size | 6.8 MiB |
| NONE | |
|---|---|
| UNKNOWN | 47701 |
| TOTALLY EJECTED | 3586 |
| PARTIALLY EJECTED | 971 |
| TRAPPED/EXTRICATED | 542 |
| Value | Count | Frequency (%) | |
| NONE | 833584 | 92.9% | |
| UNKNOWN | 47701 | 5.3% | |
| TOTALLY EJECTED | 3586 | 0.4% | |
| PARTIALLY EJECTED | 971 | 0.1% | |
| TRAPPED/EXTRICATED | 542 | 0.1% | |
| (Missing) | 11022 | 1.2% |
Length
| Max length | 18 |
|---|---|
| Median length | 4 |
| Mean length | 4.213658032 |
| Min length | 3 |
INJURY_CLASSIFICATION
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 348 |
| Missing (%) | < 0.1% |
| Memory size | 6.8 MiB |
| NO INDICATION OF INJURY | |
|---|---|
| NONINCAPACITATING INJURY | 37467 |
| REPORTED, NOT EVIDENT | 23090 |
| INCAPACITATING INJURY | 7462 |
| FATAL | 384 |
| Value | Count | Frequency (%) | |
| NO INDICATION OF INJURY | 828655 | 92.3% | |
| NONINCAPACITATING INJURY | 37467 | 4.2% | |
| REPORTED, NOT EVIDENT | 23090 | 2.6% | |
| INCAPACITATING INJURY | 7462 | 0.8% | |
| FATAL | 384 | < 0.1% | |
| (Missing) | 348 | < 0.1% |
Length
| Max length | 24 |
|---|---|
| Median length | 23 |
| Mean length | 22.95820286 |
| Min length | 3 |
| Distinct count | 4356 |
|---|---|
| Unique (%) | 2.7% |
| Missing | 733805 |
| Missing (%) | 81.8% |
| Memory size | 6.8 MiB |
| REFUSED | |
|---|---|
| DNA | |
| NONE | |
| 99 | 6561 |
| DECLINED | 3528 |
| Other values (4351) |
| Value | Count | Frequency (%) | |
| REFUSED | 55144 | 6.1% | |
| DNA | 24612 | 2.7% | |
| NONE | 14476 | 1.6% | |
| 99 | 6561 | 0.7% | |
| DECLINED | 3528 | 0.4% | |
| REFUSED EMS | 2133 | 0.2% | |
| HOLY CROSS | 2122 | 0.2% | |
| UNKNOWN | 1941 | 0.2% | |
| UNIVERSITY OF CHICAGO | 1927 | 0.2% | |
| STROGER | 1574 | 0.2% | |
| Other values (4346) | 49583 | 5.5% | |
| (Missing) | 733805 | 81.8% |
Length
| Max length | 50 |
|---|---|
| Median length | 3 |
| Mean length | 3.946278496 |
| Min length | 1 |
| Distinct count | 5461 |
|---|---|
| Unique (%) | 5.2% |
| Missing | 792989 |
| Missing (%) | 88.4% |
| Memory size | 6.8 MiB |
| DNA | |
|---|---|
| CFD | |
| REFUSED | |
| NONE | 7374 |
| 99 | 6323 |
| Other values (5456) |
| Value | Count | Frequency (%) | |
| DNA | 21757 | 2.4% | |
| CFD | 15122 | 1.7% | |
| REFUSED | 11087 | 1.2% | |
| NONE | 7374 | 0.8% | |
| 99 | 6323 | 0.7% | |
| UNK | 632 | 0.1% | |
| UNKNOWN | 596 | 0.1% | |
| CFD AMB | 586 | 0.1% | |
| DECLINED | 443 | < 0.1% | |
| REFUSED EMS | 295 | < 0.1% | |
| Other values (5451) | 40202 | 4.5% | |
| (Missing) | 792989 | 88.4% |
Length
| Max length | 36 |
|---|---|
| Median length | 3 |
| Mean length | 3.236334502 |
| Min length | 1 |
| Distinct count | 846 |
|---|---|
| Unique (%) | 5.2% |
| Missing | 881237 |
| Missing (%) | 98.2% |
| Memory size | 6.8 MiB |
| DNA | |
|---|---|
| NONE | 1251 |
| 99 | 916 |
| REFUSED | 450 |
| 55 | 246 |
| Other values (841) |
| Value | Count | Frequency (%) | |
| DNA | 3092 | 0.3% | |
| NONE | 1251 | 0.1% | |
| 99 | 916 | 0.1% | |
| REFUSED | 450 | 0.1% | |
| 55 | 246 | < 0.1% | |
| 24 | 219 | < 0.1% | |
| 36 | 218 | < 0.1% | |
| 10 | 217 | < 0.1% | |
| 23 | 207 | < 0.1% | |
| 70 | 195 | < 0.1% | |
| Other values (836) | 9158 | 1.0% | |
| (Missing) | 881237 | 98.2% |
Length
| Max length | 17 |
|---|---|
| Median length | 3 |
| Mean length | 2.999472925 |
| Min length | 1 |
| Distinct count | 20 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 177503 |
| Missing (%) | 19.8% |
| Memory size | 6.8 MiB |
| NONE | |
|---|---|
| UNKNOWN | |
| FAILED TO YIELD | |
| OTHER | |
| FOLLOWED TOO CLOSELY | 49040 |
| Other values (15) |
| Value | Count | Frequency (%) | |
| NONE | 266637 | 29.7% | |
| UNKNOWN | 163244 | 18.2% | |
| FAILED TO YIELD | 68901 | 7.7% | |
| OTHER | 60349 | 6.7% | |
| FOLLOWED TOO CLOSELY | 49040 | 5.5% | |
| IMPROPER BACKING | 23705 | 2.6% | |
| IMPROPER LANE CHANGE | 20069 | 2.2% | |
| IMPROPER TURN | 19426 | 2.2% | |
| IMPROPER PASSING | 16231 | 1.8% | |
| TOO FAST FOR CONDITIONS | 11865 | 1.3% | |
| Other values (10) | 20436 | 2.3% | |
| (Missing) | 177503 | 19.8% |
Length
| Max length | 33 |
|---|---|
| Median length | 5 |
| Mean length | 7.908088424 |
| Min length | 3 |
| Distinct count | 14 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 177721 |
| Missing (%) | 19.8% |
| Memory size | 6.8 MiB |
| NOT OBSCURED | |
|---|---|
| UNKNOWN | |
| OTHER | 7712 |
| MOVING VEHICLES | 4754 |
| PARKED VEHICLES | 2700 |
| Other values (9) | 4122 |
| Value | Count | Frequency (%) | |
| NOT OBSCURED | 404141 | 45.0% | |
| UNKNOWN | 296256 | 33.0% | |
| OTHER | 7712 | 0.9% | |
| MOVING VEHICLES | 4754 | 0.5% | |
| PARKED VEHICLES | 2700 | 0.3% | |
| WINDSHIELD (WATER/ICE) | 2379 | 0.3% | |
| BLINDED - SUNLIGHT | 867 | 0.1% | |
| TREES, PLANTS | 329 | < 0.1% | |
| BUILDINGS | 298 | < 0.1% | |
| BLINDED - HEADLIGHTS | 71 | < 0.1% | |
| Other values (4) | 178 | < 0.1% | |
| (Missing) | 177721 | 19.8% |
Length
| Max length | 22 |
|---|---|
| Median length | 7 |
| Mean length | 8.56407022 |
| Min length | 3 |
| Distinct count | 12 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 176972 |
| Missing (%) | 19.7% |
| Memory size | 6.8 MiB |
| NORMAL | |
|---|---|
| UNKNOWN | |
| IMPAIRED - ALCOHOL | 3506 |
| REMOVED BY EMS | 2775 |
| FATIGUED/ASLEEP | 1910 |
| Other values (7) | 5103 |
| Value | Count | Frequency (%) | |
| NORMAL | 489163 | 54.5% | |
| UNKNOWN | 217977 | 24.3% | |
| IMPAIRED - ALCOHOL | 3506 | 0.4% | |
| REMOVED BY EMS | 2775 | 0.3% | |
| FATIGUED/ASLEEP | 1910 | 0.2% | |
| OTHER | 1907 | 0.2% | |
| EMOTIONAL | 1379 | 0.2% | |
| ILLNESS/FAINTED | 625 | 0.1% | |
| HAD BEEN DRINKING | 588 | 0.1% | |
| IMPAIRED - DRUGS | 400 | < 0.1% | |
| Other values (2) | 204 | < 0.1% | |
| (Missing) | 176972 | 19.7% |
Length
| Max length | 28 |
|---|---|
| Median length | 6 |
| Mean length | 5.765636735 |
| Min length | 3 |
| Distinct count | 23 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 880703 |
| Missing (%) | 98.1% |
| Memory size | 6.8 MiB |
| CROSSING - WITH SIGNAL | |
|---|---|
| WITH TRAFFIC | |
| OTHER ACTION | |
| UNKNOWN/NA | |
| CROSSING - AGAINST SIGNAL | 872 |
| Other values (18) |
| Value | Count | Frequency (%) | |
| CROSSING - WITH SIGNAL | 3548 | 0.4% | |
| WITH TRAFFIC | 2843 | 0.3% | |
| OTHER ACTION | 2204 | 0.2% | |
| UNKNOWN/NA | 2197 | 0.2% | |
| CROSSING - AGAINST SIGNAL | 872 | 0.1% | |
| NO ACTION | 848 | 0.1% | |
| NOT AT INTERSECTION | 814 | 0.1% | |
| CROSSING - NO CONTROLS (NOT AT INTERSECTION) | 592 | 0.1% | |
| AGAINST TRAFFIC | 575 | 0.1% | |
| CROSSING - NO CONTROLS (AT INTERSECTION) | 476 | 0.1% | |
| Other values (13) | 1734 | 0.2% | |
| (Missing) | 880703 | 98.1% |
Length
| Max length | 49 |
|---|---|
| Median length | 3 |
| Mean length | 3.276703075 |
| Min length | 3 |
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 880744 |
| Missing (%) | 98.1% |
| Memory size | 6.8 MiB |
| NO CONTRASTING CLOTHING | |
|---|---|
| CONTRASTING CLOTHING | 2239 |
| OTHER LIGHT SOURCE USED | 816 |
| REFLECTIVE MATERIAL | 413 |
| Value | Count | Frequency (%) | |
| NO CONTRASTING CLOTHING | 13194 | 1.5% | |
| CONTRASTING CLOTHING | 2239 | 0.2% | |
| OTHER LIGHT SOURCE USED | 816 | 0.1% | |
| REFLECTIVE MATERIAL | 413 | < 0.1% | |
| (Missing) | 880744 | 98.1% |
Length
| Max length | 23 |
|---|---|
| Median length | 3 |
| Mean length | 3.362011174 |
| Min length | 3 |
| Distinct count | 8 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 880701 |
| Missing (%) | 98.1% |
| Memory size | 6.8 MiB |
| IN ROADWAY | |
|---|---|
| IN CROSSWALK | |
| UNKNOWN/NA | 1325 |
| BIKEWAY | 841 |
| NOT IN ROADWAY | 733 |
| Other values (3) | 513 |
| Value | Count | Frequency (%) | |
| IN ROADWAY | 7732 | 0.9% | |
| IN CROSSWALK | 5561 | 0.6% | |
| UNKNOWN/NA | 1325 | 0.1% | |
| BIKEWAY | 841 | 0.1% | |
| NOT IN ROADWAY | 733 | 0.1% | |
| DRIVEWAY ACCESS | 244 | < 0.1% | |
| BIKE LANE | 229 | < 0.1% | |
| SHOULDER | 40 | < 0.1% | |
| (Missing) | 880701 | 98.1% |
Length
| Max length | 15 |
|---|---|
| Median length | 3 |
| Mean length | 3.144167746 |
| Min length | 3 |
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 176397 |
| Missing (%) | 19.7% |
| Memory size | 6.8 MiB |
| TEST NOT OFFERED | |
|---|---|
| TEST REFUSED | 7651 |
| TEST PERFORMED, RESULTS UNKNOWN | 1799 |
| TEST TAKEN | 1289 |
| Value | Count | Frequency (%) | |
| TEST NOT OFFERED | 710270 | 79.1% | |
| TEST REFUSED | 7651 | 0.9% | |
| TEST PERFORMED, RESULTS UNKNOWN | 1799 | 0.2% | |
| TEST TAKEN | 1289 | 0.1% | |
| (Missing) | 176397 | 19.7% |
Length
| Max length | 31 |
|---|---|
| Median length | 16 |
| Mean length | 13.43202742 |
| Min length | 3 |
| Distinct count | 50 |
|---|---|
| Unique (%) | 4.4% |
| Missing | 896257 |
| Missing (%) | 99.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.16929503916449085 |
|---|---|
| Minimum | 0.0 |
| Maximum | 0.99 |
| Zeros | 103 |
| Zeros (%) | < 0.1% |
| Memory size | 6.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0.12 |
| median | 0.17 |
| Q3 | 0.21 |
| 95-th percentile | 0.3 |
| Maximum | 0.99 |
| Range | 0.99 |
| Interquartile range (IQR) | 0.09 |
Descriptive statistics
| Standard deviation | 0.09811609147 |
|---|---|
| Coefficient of variation (CV) | 0.5795568019 |
| Kurtosis | 12.80452339 |
| Mean | 0.1692950392 |
| Median Absolute Deviation (MAD) | 0.05 |
| Skewness | 1.780141616 |
| Sum | 194.52 |
| Variance | 0.009626767406 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0 | 103 | < 0.1% | |
| 0.17 | 83 | < 0.1% | |
| 0.18 | 82 | < 0.1% | |
| 0.21 | 74 | < 0.1% | |
| 0.14 | 69 | < 0.1% | |
| 0.2 | 60 | < 0.1% | |
| 0.19 | 59 | < 0.1% | |
| 0.15 | 55 | < 0.1% | |
| 0.22 | 50 | < 0.1% | |
| 0.16 | 48 | < 0.1% | |
| Other values (40) | 466 | 0.1% | |
| (Missing) | 896257 | 99.9% |
| Value | Count | Frequency (%) | |
| 0 | 103 | < 0.1% | |
| 0.01 | 3 | < 0.1% | |
| 0.02 | 4 | < 0.1% | |
| 0.03 | 14 | < 0.1% | |
| 0.04 | 10 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0.99 | 1 | < 0.1% | |
| 0.95 | 1 | < 0.1% | |
| 0.88 | 1 | < 0.1% | |
| 0.8 | 1 | < 0.1% | |
| 0.79 | 1 | < 0.1% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| PERSON_ID | PERSON_TYPE | CRASH_RECORD_ID | RD_NO | VEHICLE_ID | CRASH_DATE | SEAT_NO | CITY | STATE | ZIPCODE | SEX | AGE | DRIVERS_LICENSE_STATE | DRIVERS_LICENSE_CLASS | SAFETY_EQUIPMENT | AIRBAG_DEPLOYED | EJECTION | INJURY_CLASSIFICATION | HOSPITAL | EMS_AGENCY | EMS_RUN_NO | DRIVER_ACTION | DRIVER_VISION | PHYSICAL_CONDITION | PEDPEDAL_ACTION | PEDPEDAL_VISIBILITY | PEDPEDAL_LOCATION | BAC_RESULT | BAC_RESULT VALUE | CELL_PHONE_USE | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | O10 | DRIVER | 2e31858c0e411f0bdcb337fb7c415aa93763cf2f23e02fb278e2ed4cf855d36c5a83f270e6f2e0e234ec48b4a0e55a2c51e37b0d40677392c25079c51727a57f | HY368708 | 10.0 | 08/04/2015 12:40:00 PM | NaN | CHICAGO | IL | 60641 | M | NaN | NaN | NaN | USAGE UNKNOWN | NOT APPLICABLE | NONE | NO INDICATION OF INJURY | NaN | NaN | NaN | FAILED TO YIELD | UNKNOWN | NORMAL | NaN | NaN | NaN | TEST NOT OFFERED | NaN | NaN |
| 1 | O100 | DRIVER | e73b35bd7651b0c6693162bee0666db159b2890143700936741e9ad9cfc1b0d7f71c0f63dc0594ecdd6fd2183fa2dcd67dfa76a4799839a00a81bc45e3966bb1 | HY374018 | 96.0 | 07/31/2015 05:50:00 PM | NaN | ELK GROVE | IL | 60007 | M | NaN | NaN | NaN | SAFETY BELT USED | DID NOT DEPLOY | NONE | NO INDICATION OF INJURY | NaN | NaN | NaN | FOLLOWED TOO CLOSELY | UNKNOWN | NORMAL | NaN | NaN | NaN | TEST NOT OFFERED | NaN | NaN |
| 2 | O1000 | DRIVER | f2b1adeb85a15112e4fb7db74bff440d6ca53ff7a21e10490081685db85460a53c0f3d52dc0e181e69348053ef3198dccbc24e01df9179e42331bc4345e6f28d | HY407431 | 954.0 | 09/02/2015 11:45:00 AM | NaN | CHICAGO | IL | NaN | M | 31.0 | IL | D | USAGE UNKNOWN | DID NOT DEPLOY | NONE | NO INDICATION OF INJURY | NaN | NaN | NaN | UNKNOWN | UNKNOWN | NORMAL | NaN | NaN | NaN | TEST NOT OFFERED | NaN | NaN |
| 3 | O10000 | DRIVER | 15a3e24fce3ce7cd2b02d44013d1a93ff2fbdca80632ecca87150673b21e819bd8649e309f867728fd25a9a9fcb6f0f2c00c42ab6733e4d6945262dbe6c90c0e | HY484148 | 9561.0 | 10/31/2015 09:30:00 PM | NaN | SKOKIE | IL | 60076 | M | 29.0 | IL | D | SAFETY BELT USED | DID NOT DEPLOY | NONE | NO INDICATION OF INJURY | NaN | NaN | NaN | NONE | NOT OBSCURED | NORMAL | NaN | NaN | NaN | TEST NOT OFFERED | NaN | NaN |
| 4 | O100001 | DRIVER | 2fcefeab458932d8b1b12e103c18c50adc659943cccd4b17fc22124a16b1ba9df582f703cd07e7ba892d00b904c9a9849b7c0b6a39063c00e829a752fe22f206 | HZ525619 | 96762.0 | 11/15/2016 05:45:00 PM | NaN | NaN | NaN | NaN | X | NaN | NaN | NaN | USAGE UNKNOWN | DEPLOYMENT UNKNOWN | UNKNOWN | NO INDICATION OF INJURY | NaN | NaN | NaN | UNKNOWN | UNKNOWN | UNKNOWN | NaN | NaN | NaN | TEST NOT OFFERED | NaN | NaN |
| 5 | O100002 | DRIVER | 2fcefeab458932d8b1b12e103c18c50adc659943cccd4b17fc22124a16b1ba9df582f703cd07e7ba892d00b904c9a9849b7c0b6a39063c00e829a752fe22f206 | HZ525619 | 96754.0 | 11/15/2016 05:45:00 PM | NaN | CHICAGO | IL | 60619 | F | 63.0 | NaN | NaN | SAFETY BELT USED | DID NOT DEPLOY | NONE | NO INDICATION OF INJURY | NaN | NaN | NaN | NONE | NOT OBSCURED | NORMAL | NaN | NaN | NaN | TEST NOT OFFERED | NaN | NaN |
| 6 | O100003 | DRIVER | c2f21fd14725cf30d43ae59057e59b2e225c9e62a846e7995a6fbf041a23f4578ac02ec12570a1451580b566e134a1aeccceabfc653a1b9a8ca87d122d2bd3e8 | HZ525629 | 96757.0 | 11/22/2016 01:45:00 PM | NaN | PARKRIDGE | IL | NaN | F | 20.0 | IL | D | USAGE UNKNOWN | DEPLOYMENT UNKNOWN | NONE | NO INDICATION OF INJURY | NaN | NaN | NaN | FOLLOWED TOO CLOSELY | NOT OBSCURED | NORMAL | NaN | NaN | NaN | TEST NOT OFFERED | NaN | NaN |
| 7 | O100004 | DRIVER | c2f21fd14725cf30d43ae59057e59b2e225c9e62a846e7995a6fbf041a23f4578ac02ec12570a1451580b566e134a1aeccceabfc653a1b9a8ca87d122d2bd3e8 | HZ525629 | 96755.0 | 11/22/2016 01:45:00 PM | NaN | CHICAGO | IL | 60646 | M | 18.0 | IL | D | SAFETY BELT USED | DID NOT DEPLOY | NONE | NO INDICATION OF INJURY | REFUSED | NaN | NaN | NONE | NOT OBSCURED | NORMAL | NaN | NaN | NaN | TEST NOT OFFERED | NaN | NaN |
| 8 | O100005 | DRIVER | 5bfddf5ec81892bf71c2ba0f807c1ec112fd7ecdecbf3c6abbcea4314d7333fc6a4a058537ee8e97dbbb73019444b810f8aabe493003563d25736a5bd2c278a9 | HZ525606 | 96759.0 | 11/19/2016 06:35:00 PM | NaN | BUFFALO GROVE | IL | 60089 | F | 30.0 | IL | NaN | USAGE UNKNOWN | DID NOT DEPLOY | NONE | NO INDICATION OF INJURY | NaN | NaN | NaN | IMPROPER LANE CHANGE | UNKNOWN | UNKNOWN | NaN | NaN | NaN | TEST NOT OFFERED | NaN | NaN |
| 9 | O100006 | DRIVER | 5bfddf5ec81892bf71c2ba0f807c1ec112fd7ecdecbf3c6abbcea4314d7333fc6a4a058537ee8e97dbbb73019444b810f8aabe493003563d25736a5bd2c278a9 | HZ525606 | 96760.0 | 11/19/2016 06:35:00 PM | NaN | CHICAGO | IL | 60625 | M | 50.0 | IL | D | SAFETY BELT USED | DID NOT DEPLOY | NONE | NO INDICATION OF INJURY | NaN | NaN | NaN | NONE | NOT OBSCURED | NORMAL | NaN | NaN | NaN | TEST NOT OFFERED | NaN | NaN |
Last rows
| PERSON_ID | PERSON_TYPE | CRASH_RECORD_ID | RD_NO | VEHICLE_ID | CRASH_DATE | SEAT_NO | CITY | STATE | ZIPCODE | SEX | AGE | DRIVERS_LICENSE_STATE | DRIVERS_LICENSE_CLASS | SAFETY_EQUIPMENT | AIRBAG_DEPLOYED | EJECTION | INJURY_CLASSIFICATION | HOSPITAL | EMS_AGENCY | EMS_RUN_NO | DRIVER_ACTION | DRIVER_VISION | PHYSICAL_CONDITION | PEDPEDAL_ACTION | PEDPEDAL_VISIBILITY | PEDPEDAL_LOCATION | BAC_RESULT | BAC_RESULT VALUE | CELL_PHONE_USE | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 897396 | P204385 | PASSENGER | 93ae9608099cc936377a3c103955600be620c8361e59a1d79a686981683c2cf58425710634c96c17c43d69623005cfdcc4876a010c3090b66541b13318f24c05 | JD254733 | 848712.0 | 06/05/2020 02:45:00 PM | 7.0 | CHICAGO | IL | NaN | F | 25.0 | NaN | NaN | SAFETY BELT NOT USED | DID NOT DEPLOY | NONE | NONINCAPACITATING INJURY | JACKSON PARK | CFD | 55 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 897397 | P204386 | PASSENGER | 93ae9608099cc936377a3c103955600be620c8361e59a1d79a686981683c2cf58425710634c96c17c43d69623005cfdcc4876a010c3090b66541b13318f24c05 | JD254733 | 848712.0 | 06/05/2020 02:45:00 PM | 7.0 | CHICAGO | IL | 60649 | F | 68.0 | NaN | NaN | SAFETY BELT NOT USED | DID NOT DEPLOY | NONE | NO INDICATION OF INJURY | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 897398 | P204387 | PASSENGER | 93ae9608099cc936377a3c103955600be620c8361e59a1d79a686981683c2cf58425710634c96c17c43d69623005cfdcc4876a010c3090b66541b13318f24c05 | JD254733 | 848712.0 | 06/05/2020 02:45:00 PM | 7.0 | CHICAGO | IL | 60637 | F | 53.0 | NaN | NaN | SAFETY BELT NOT USED | DID NOT DEPLOY | NONE | NO INDICATION OF INJURY | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 897399 | P204389 | PASSENGER | 93ae9608099cc936377a3c103955600be620c8361e59a1d79a686981683c2cf58425710634c96c17c43d69623005cfdcc4876a010c3090b66541b13318f24c05 | JD254733 | 848712.0 | 06/05/2020 02:45:00 PM | 7.0 | CHICAGO | IL | 60637 | F | 39.0 | NaN | NaN | SAFETY BELT NOT USED | NOT APPLICABLE | NONE | NO INDICATION OF INJURY | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 897400 | P204390 | PASSENGER | 93ae9608099cc936377a3c103955600be620c8361e59a1d79a686981683c2cf58425710634c96c17c43d69623005cfdcc4876a010c3090b66541b13318f24c05 | JD254733 | 848712.0 | 06/05/2020 02:45:00 PM | 7.0 | CHICAGO | IL | 60637 | F | 17.0 | NaN | NaN | SAFETY BELT NOT USED | NOT APPLICABLE | NONE | NO INDICATION OF INJURY | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 897401 | P204448 | PASSENGER | 0abfcb63aff48dbc1c1b628ea327e320f315f557c9f7d9793eecf1c26e89f866c361c03eb7b63ec22c4de39d03589c9fc850e10ba64042fcb74dcb3943d4f1aa | JD254459 | 849068.0 | 06/05/2020 10:57:00 AM | 6.0 | CHICAGO | IL | 60644 | F | 55.0 | NaN | NaN | SAFETY BELT USED | DID NOT DEPLOY | NONE | REPORTED, NOT EVIDENT | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 897402 | P204454 | PASSENGER | 02b88fc435881e3ede873b59dcca638305a953f0e29b64e53d09901c59d012ce396988e41e4a4f4e612c3b0a5006db338d8315f3be1307b436eb708bfa967a9d | JD254908 | 848444.0 | 06/05/2020 05:00:00 PM | 3.0 | NaN | IL | NaN | X | NaN | NaN | NaN | USAGE UNKNOWN | NOT APPLICABLE | NONE | NO INDICATION OF INJURY | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 897403 | P204866 | PASSENGER | 4d4315d6432fab513f270f7cd9e60bd5b1b03be7524e38e7de0231505d76ced4e886bb7cc13aec0365c85f772f93b18fe96863d7f4ef30000f2856e46bae8b25 | JD259079 | 850812.0 | 06/05/2020 12:20:00 PM | 4.0 | NaN | NaN | NaN | M | 16.0 | NaN | NaN | SAFETY BELT USED | NOT APPLICABLE | NONE | NO INDICATION OF INJURY | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 897404 | P204880 | PASSENGER | 6e0932de2a9bc3969bd708b25b233496a36fb0892232ef3a416a9aab4ea90e9d117fbb0b89c880fd37024f2dee65a92f138998914db69219f409d63ca123f520 | JD259879 | 850898.0 | 06/05/2020 07:00:00 PM | 3.0 | NaN | NaN | NaN | F | NaN | NaN | NaN | USAGE UNKNOWN | DID NOT DEPLOY | NONE | NO INDICATION OF INJURY | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 897405 | P204881 | PASSENGER | 6e0932de2a9bc3969bd708b25b233496a36fb0892232ef3a416a9aab4ea90e9d117fbb0b89c880fd37024f2dee65a92f138998914db69219f409d63ca123f520 | JD259879 | 850898.0 | 06/05/2020 07:00:00 PM | 6.0 | CHICAGO | IL | 60637 | M | 5.0 | NaN | NaN | USAGE UNKNOWN | DID NOT DEPLOY | NONE | NO INDICATION OF INJURY | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |